 IF NOT EXISTS
(
    SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'tblGuy_Info'
          AND COLUMN_NAME = 'AgreementCode'
)
    ALTER TABLE dbo.tblGuy_Info ADD AgreementCode varchar(15) NULL;